package com.zxl.working.mapper.backend;

import com.zxl.working.entity.backend.SellerProject;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.beans.factory.annotation.Qualifier;

@Mapper
@Qualifier("backEndSqlSessionTemplate")
public interface SellerProjectMapper {


    @Insert("INSERT INTO `backend`.`seller_project` (`project_id`,`project_name`,`charge_name`,`telephone`," +
            "  `project_requirement`,`file_path`,`seller_id`, `created_time`,`status`,`project_code`)" +
            "VALUES(#{projectId},#{projectName},#{chargeName},#{telephone}, #{projectRequirement}," +
            "    #{filePath},#{sellerId}, #{createdTime},#{status},#{projectCode});")
    void insSellerProject(SellerProject sellerProject);


    @Delete("delete from seller_project where project_code=#{orderId}")
    void deleteByOrderId(@Param("orderId")String orderId);
}
